Board index MS EXCEL

SUMIF formula required to search for 2 diff values in 2 diff c

SUMIF formula required to search for 2 diff values in 2 diff c

Post by TGlkeTY5M » Mon, 23 Feb 2009 06:01:01


Thanks Mike - that works a treat, much appreciated
--
Lidy
 
 
 
Top

SUMIF formula required to search for 2 diff values in 2 diff c

Post by TGlkeTY5M » Mon, 23 Feb 2009 06:02:01

Thanks Biff, i'm so relieved now that i can calculate these totals, much
appreciated
--
Lidy

 
 
 
Top

SUMIF formula required to search for 2 diff values in 2 diff c

Post by TWlrZSB » Mon, 23 Feb 2009 06:05:01

Hi,

Your welcome, glad i could help. I have a question, as soon as I saw Biff's
response I was convinced I had misunderstood the question and we should be
summing the ones in column C (which be 2 or 3) which his formula does, what
is the purpose of column C?

Mike
 
 
 
Top

SUMIF formula required to search for 2 diff values in 2 diff c

Post by T. Valk » Mon, 23 Feb 2009 06:45:48

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP
 
 
 
Top

1. [PATCH 8/9] tip-diff-origin: use git-diff instead of a tempfile and plain diff

2. diff colors for diff values in combobox

3. How do I replace text within a formula with a diff cell value?

4. Create formula that will pull a value based on text in diff cell?

5. Formula pull factor from chart based on value of diff field?

6. returning records by comparing 2 diff fields of diff records

7. how you make links between diff. cells on diff. work sheets

8. Using Powerpoint to show diff. slides at diff. times

9. how do i list diff.task for diff.months so march does not show on.

10. how to send emails to my diff. email addresses to diff. folders

11. Query yields diff results on diff plats

12. Diff CSS styles for diff INPUT TYPE='s?

13. [ANN] Diff::LCS 1.1.0, Diff::LCS 1.0.4

14. with multiple external ips, send mail from diff domains specifying diff ip for each with 2003?

15. diff.c unexpected non-minimal diff error

All times are UTC
Board index